2014-01-09 - 10654.200 - Spec - Japan and Brazil data #SalesDistribution
SPECIFICATIONS
10654.200 - Japan and Brazil data
Requirement Summary
Need to create source for Brazil & Japan data in BPD(BW 7.3 Development) & Load Brazil & Japan data in BW system to create a new Multiprovider.
Admin Info
Purpose
|
Create source for Japan & Brazil data & Load data in BW system to create a new Multi provider.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
01/09/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Brazil & Japan Sales Analysis Cube(ZBJ_SALES),
Brazil & Japan Open Orders Cube(ZBJ_OPEN) and
Scorecard Multiprovider(ZMP_SCARD).
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
Attached with related release note.
Functional Requirement
1. Need to create infoobjects for Sales Quantity, Sales Revenue, Open Quantity & Open Revenue to meet the NEC requirement.
2. Need to create new infocube for Brazil & Japan Open Orders with required Characteristics, Key Figures and Navigational Attributes to meet NEC requirement.
3. Need to create new infocube for Brazil & Japan Sales Analysis with required Characteristics, Key Figures and Navigational Attributes to meet NEC requirement.
4. Need to create new Multiprovider to combine Open orders & Sales Analysis of Brazil & Japan information with COPA, Open Orders, Order Condition, Contract, BPC Budget data and Retail infocubes.
5. Need to create transport requests in BPD(BW 7.3 Development) and collect all the objects like infoobjects, infocubes, Multiprovider & their dataflows.
Solution Summary
1. Need to create infoobjects for Sales Quantity, Sales Revenue, Open Quantity & Open Revenue to meet the NEC requirement.
2. Need to create a new infocube for Brazil & Japan Open Orders with required Characteristics, Key Figures and Navigational Attributes.
3. Need to create the datasources by using flat file source system.
4. Need to create transformations for Brazil & Japan Open Orders infocube with Japan datasource & Brazil datasource.
5. Need to create full load infopackage as Brazil & Japan Open orders is always full load due to file interface.
6. Need to create the Data Transfer Process between infocube and datasource.
7. Need to create another infocube for Brazil & Japan Sales Analysis with required Characteristics, Key Figures and Navigational Attributes.
8. Need to create transformations for Brazil & Japan Sales Analysis infocube with Japan datasource & Brazil datasource.
9. Need to create full load infopackage as Brazil & Japan Open orders is always full load due to file interface.
10. Need to create the Data Transfer Process between infocube and datasource.
11. Need to create new Multiprovider to combine Open orders, Sales Analysis of Brazil & Japan information with COPA, Open Orders, Order Condition, Contract, BPC Budget data and Retail infocubes.
12. Need to assign the infoobjects in Multiprovider from respective infoproviders as per NEC requirement.
13. Need to collect the infoobjects, infocubes, Multiprovider & their dataflows in separate transport requests.
14. Unit Test the sources in BPD(BW 7.3 Development) and then transport them to BPQ(BW 7.3 Quality) for further testing.
Test Plan
SNo.
|
Test Scenario
|
Expected Results
|
1
|
Check if the data is correctly loaded into Brazil & Japan Open Orders cube.
|
Data should be correctly loaded.
|
2
|
Check if the data is correctly loaded in to Brazil & Japan Sales Analysis cube.
|
Data should be correctly loaded.
|
3
|
Check the above sources against NEC Standard Infoprovider development checklist.
|
Infoproviders should be successfully validated as per NEC checklist.
|
Solution Details
1. Need to create infoobjects for Sales Quantity ZBJ_SAQTY, Sales Revenue ZBJ_SAREV, Open Quantity ZBJ_OOQTY & Open Revenue ZBJ_OOREV to meet the NEC requirement.
2. Need to create a new infocube for Brazil & Japan Open Orders ZBJ_OPEN with required Characteristics, Key Figures and Navigational Attributes.
3. Need to create the datasources ZBRAZIL_DATA, ZJAPAN_DATA by using flat file source system.
4. Need to create transformation for Brazil & Japan Open Orders cube ZBJ_OPEN with fields of Japan datasource ZJAPAN_DATA & Brazil datasource ZBRAZIL_DATA.
5. Need to create full load infopackage as Brazil & Japan open orders is always full load due to file interface.
6. Need to create the Data Transfer Process between infocube ZBJ_OPEN and datasources ZJAPAN_DATA & ZBRAZIL_DATA.
7. Need to create another infocube for Brazil & Japan Sales Analysis ZBJ_SALES with required Characteristics, Key Figures and Navigational Attributes.
8. Need to create transformation for Brazil & Japan Sales Analysis cube ZBJ_SALES with Japan datasource ZJAPAN_DATA & Brazil datasource ZBRAZIL_DATA.
9. Need to create full load infopackage as Brazil & Japan Open orders is always full load due to file interface.
10. Need to create the Data Transfer Process between infocube ZBJ_SALES and datasources ZJAPAN_DATA & ZBRAZIL_DATA.
11. Need to create new Multiprovider ZMP_SCARD to combine Open orders, Sales Analysis of Brazil & Japan information with COPA ZCOPA_C03, Open Orders ZSDC_OPN, Order Condition ZSD_C15, Contract ZSD_CONTR, BPC Budget data ZBPC_PLAN and Retail ZRETAIL infocubes.
12. Need to assign the infoobjects in Multiprovider ZMP_SCARD from respective infoproviders as per NEC requirement.
13. Need to collect the infoobjects ZBJ_SAREV, ZBJ_SAQTY, ZBJ_OOQTY, ZBJ_OOREV, infocubes ZBJ_OPEN, ZBJ_SALES, Multiprovider ZMP_SCARD & their dataflows in separate transport requests.
14. Need to check whether all the objects are collected into the transport requests & then transport them to BPQ(BW 7.3 Quality) for further testing.
Issues
None